
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
Preparing to use the Adaptive Server database</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="connpbp37.htm">Previous</A>&nbsp;&nbsp;<A HREF="connpbp39.htm" >Next</A>
<!-- End Header -->
<A NAME="X-REF307817801"></A><h1>Preparing to use the Adaptive Server database</h1>
<A NAME="TI737"></A><p>Before you define the interface and connect to an Adaptive
Server database in PowerBuilder, follow these steps to prepare the
database for use: <A NAME="TI738"></A>
<ol>
</li>
<li class=ds>Install and configure the required
database server, network, and client software.</li>
<li class=ds>Install the Adaptive Server database interface.</li>
<li class=ds>Verify that you can connect to Adaptive Server outside PowerBuilder.</li>
<li class=ds>Install the required PowerBuilder stored procedures
in the sybsystemprocs database.
</li>
</ol>
</p>
<A NAME="TI739"></A><p>Preparing an Adaptive Server database for use with PowerBuilder involves these
four basic tasks.</p>
<A NAME="TI740"></A><h4>Step 1: Install and configure the database server</h4>
<A NAME="TI741"></A><p>You must install and configure the database server, network,
and client software for Adaptive Server.</p>
<A NAME="TI742"></A><p><img src="images/proc.gif" width=17 height=17 border=0 align="bottom" alt="Steps"> To install and configure the database server,
network, and client software:</p>
<ol><li class=fi><p>Make sure the Adaptive Server database
software is installed on the server specified in your database profile.</p><p>You must obtain the database server software from Sybase.</p><p>For installation instructions, see your Adaptive
Server documentation.</p></li>
<li class=ds><p>Make sure the supported network software (for
example, TCP/IP) is installed and running on your computer
and is properly configured so that you can connect to the database
server at your site.</p><p>You must install the network communication driver that supports
the network protocol and operating system platform you are using.
The driver is installed as part of the Net-Library client software.</p><p>For installation and configuration instructions,
see your network or database administrator.</p></li>
<li class=ds><p>Install the required Open Client CT-Library (CT-Lib)
software on each client computer on which PowerBuilder is installed.</p><p>You must obtain the Open Client software from Sybase. Make
sure the version of Open Client you install supports <i>all</i> of
the following:<A NAME="TI743"></A>
<ul>
<li class=fi>The operating
system running on the client computer</li>
<li class=ds>The version of Adaptive Server that you want to
access</li>
<li class=ds>The version of PowerBuilder that you are running
</li>
</ul>
</p><p><img src="images/note.gif" width=17 height=17 border=0 align="bottom" alt="Note"> <span class=shaded>Required client software versions</span> <A NAME="TI744"></A>To use the ASE Adaptive Server interface, you must install
Open Client version 15.x or later. To use the SYC Adaptive Server
interface, you must install Open Client version 11.x or later.</p>
</li>
<li class=ds><p>Make sure the Open Client software is properly
configured so that you can connect to the database at your site.</p><p>Installing the Open Client software places the <i></i><ACRONYM title = "sequel" >SQL</ACRONYM>.INI configuration
file in the Adaptive Server directory on your computer.</p><p><i></i><ACRONYM title = "sequel" >SQL</ACRONYM>.INI provides
information that Adaptive Server needs to find and connect to the
database server at your site. You can enter and modify information
in <i></i><ACRONYM title = "sequel" >SQL</ACRONYM>.INI by
using the configuration utility that comes with the Open Client
software.</p><p>For information about setting up the <i></i><ACRONYM title = "sequel" >SQL</ACRONYM>.INI or other required configuration
file, see your Adaptive Server documentation.</p></li>
<li class=ds><p>If required by your operating system, make sure
the directory containing the Open Client software is in your system
path.</p></li>
<li class=ds><p>Make sure only one copy of each of the following
files is installed on your client computer:<A NAME="TI745"></A>
<ul>
<li class=fi>Adaptive Server interface DLL</li>
<li class=ds>Network communication DLL (for example, <i>NLWNSCK.DLL</i> for Windows
Sockets-compliant TCP/IP)</li>
<li class=ds>Database vendor DLL (for example, <i>LIBCT.DLL</i>)
</li>
</ul>

                      </p></li></ol>
<br><A NAME="TI746"></A><h4>Step 2: Install the database interface</h4>
<A NAME="TI747"></A><p>In the PowerBuilder Setup program, select the Typical install,
or select the Custom install and select the Adaptive Server Enterprise
(ASE or SYC) database interface.</p>
<A NAME="TI748"></A><p>If you work with PowerBuilder and <ACRONYM title = "E A Server" >EAServer</ACRONYM>,
you should also select the Adaptive Server interface for <ACRONYM title = "E A Server" >EAServer</ACRONYM> (SYJ).</p>
<A NAME="TI749"></A><h4>Step 3: Verify the connection</h4>
<A NAME="TI750"></A><p>Make sure you can connect to the Adaptive Server database
server and log in to the database you want to access from outside PowerBuilder.</p>
<A NAME="TI751"></A><p>Some possible ways to verify the connection are by running
the following tools:<A NAME="TI752"></A>
<ul>
<li class=fi><b>Accessing the database server</b>   Tools such as the Open Client/Open Server Configuration
utility (or any Ping utility) check whether you can reach the database
server from your computer.</li>
<li class=ds><b>Accessing the database</b>   Tools such as <ACRONYM title = "I sequel" >ISQL</ACRONYM> (interactive <ACRONYM title = "sequel" >SQL</ACRONYM> utility) check whether you can
log in to the database and perform database operations. It is a
good idea to specify the same connection parameters you plan to
use in your PowerBuilder database profile to access the database.
</li>
</ul>
</p>
<A NAME="TI753"></A><h4>Step 4: Install the PowerBuilder stored procedures</h4>
<A NAME="TI754"></A><p>PowerBuilder requires you to install certain stored procedures
in the sybsystemprocs database <i>before</i> you connect
to an Adaptive Server database for the first time. PowerBuilder uses
these stored procedures to get information about tables and columns
from the DBMS system catalog.</p>
<A NAME="TI755"></A><p>Run the <ACRONYM title = "sequel" >SQL</ACRONYM> script or
scripts required to install the PowerBuilder stored procedures in
the sybsystemprocs database.</p>
<A NAME="TI756"></A><p>For instructions, see <A HREF="connpbp44.htm#CCJDBEBA">"Installing stored procedures
in Adaptive Server databases"</A>.</p>

